/* Copyright 2011 Elektrobit Wireless Communications Oy (EB)


  This program is free software; you can redistribute it and/or modify
  it under the terms of the GNU General Public License version 2 as 
  published by the Free Software Foundation.

  This program is distributed in the hope that it will be useful,
  but WITHOUT ANY WARRANTY; without even the implied warranty of
  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  GNU General Public License for more details.

  You should have received a copy of the GNU General Public License along
  with this program; if not, write to the Free Software Foundation, Inc.,
  51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.


 *All rights reserved 
 *Version:Elektrobit_Qt_1.0.0_20110305 */


#include "dbservice.h"
#include <appcommon.h>
#include <QSqlQuery>
#include <QSqlError>
#include <QSqlDriver>
#include <QVariant>


DbService::DbService(QObject *parent) : Service(parent) {
    mConnectSuccess = false;
}


void DbService::connect() {
    mDb = QSqlDatabase::addDatabase("QSQLITE");
    mDb.setDatabaseName(this->property("database_file").toString());
    mConnectSuccess = mDb.open();
    if(!mConnectSuccess) {
        APPERROR("database " + this->property("database_file").toString() + "connect error");
    }
}

QSqlQueryModel *DbService::query(const QString &sqlStr) {
    QSqlQueryModel *model = new QSqlQueryModel();
    model->setQuery(sqlStr, mDb);
    if(model->lastError().isValid()) {
        APPWARAING << "sql error " << model->lastError();
        delete model;
        return NULL;
    }
    return model;
}

int DbService::start() {
    this->connect();
    return 0;
}

int DbService::stop() {
    this->mDb.close();
    return 0;
}
